class UserSqlMap(object):
    all_friend = "select t1.real_name,t1.user_id,t2.dept_name,t1.img_path from aoa_user as t1 inner join aoa_dept as t2 on t1.dept_id=t2.dept_id where t1.user_id!={user_id}"
    check_friend = "select t1.img_path,t1.real_name,t1.user_id,t1.user_tel,t2.name as position_name,t3.role_name,t4.dept_name,t5.jobnumber from aoa_user as t1 inner join aoa_position as t2 on t1.position_id=t2.position_id inner join aoa_role_ as t3 on t1.role_id=t3.role_id inner join aoa_dept as t4 on t1.dept_id=t4.dept_id inner join aoa_humanres as t5 on t1.user_id=t5.user_id where t1.user_id={user_id}"